package com.hshoesmall.demo.mapper;

import com.hshoesmall.demo.model.entity.Detail;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface DetailMapper {

    //查询所需要的数据
//    @Select("select sid,sname,snum,sprices,sdiscount,stimessold,sintegral,simage,sizenum " +
//            "from shoes,size,shoesizes where shoes.sid=shoesizes.s_sid and shoesizes.size_id=sizes.sizeid")
    @Select("select sid,sname,snum,sprices,sdiscount,stimessold,sintegral,simage,sizenum " +
            "from ranks,sizes,shoesizes where ranks.sid=shoesizes.s_sid and shoesizes.size_id=sizes.sizeid and sid=116")
    List<Detail> findAll();

}
